﻿This AFMER Time Series 2000-2019 readme.txt file was generated on 20210607 by Lisa Jordan


-------------------
GENERAL INFORMATION
-------------------


Title of Dataset: Annual Firearms Manufacturing and Export Report, 2000-2019

Original Data Available in .PDF format from the Bureau of Alcohol, Firearms and Tobacco (ATF), 

Annual Firearms Manufacturing and Export Report, Year 2000 
1633.pdf, published March 11, 2002, web source:
https://www.hsdl.org/?search&exact=ATF+Annual+Firearms+Manufacturers+and+Export+Report&searchfield=series&collection=limited&submitted=Search&advanced=1&release=0&so=date
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2001 
AFMER-2001.pdf, published January 23, 2003, websource:
https://github.com/ryjones/AFMER
downloaded 2021-06-07
[observed a mismatch in pistol 50, and pistol totals on summary page, and pistol 50 and pistol totals on itemized page]

Annual Firearms Manufacturing and Export Report, Year 2002 
728686.pdf, published January 8, 2004, websource:	
https://www.hsdl.org/?search&exact=ATF+Annual+Firearms+Manufacturers+and+Export+Report&searchfield=series&collection=limited&submitted=Search&advanced=1&release=0&so=date
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2003
728685.pdf, published January 8, 2005, websource:
https://www.hsdl.org/?search&exact=ATF+Annual+Firearms+Manufacturers+and+Export+Report&searchfield=series&collection=limited&submitted=Search&advanced=1&release=0&so=date
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2004
728684.pdf, published March 31, 2006, websource:	
https://www.hsdl.org/?search&exact=ATF+Annual+Firearms+Manufacturers+and+Export+Report&searchfield=series&collection=limited&submitted=Search&advanced=1&release=0&so=date

Annual Firearms Manufacturing and Export Report, Year 2005
AFMER-2005.pdf, published January 29, 2008, websource:
https://github.com/ryjones/AFMER
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2006
AFMER-2006.pdf, published January 29, 2008, websource:
https://github.com/ryjones/AFMER
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2007
2007-firearms-manufacturing-export-report.pdf, published January 30, 2009, Revised May 24, 2010, websource:
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2008
2008-firearms-manufacturers-export-report.pdf, published January 14, 2010, Revised May 8, 2011, websource:
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2009
2009-firearms-manufacturers-export-report.pdf, published January 20, 2011, websource:	
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2010
2010-final-firearms-manufacturing-export-report.pdf, published January 30, 2012, websource:	
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2011
cy2011-final-firearms-manufacturing-export-report.pdf, published January 7, 2013, websource:	
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2012 
afmer_2012_final_web_report_17jan2014.pdf, published January 17, 2014, websource:
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2013 
afmer_2013_final_web_report, published February 3, 2015, websource:
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2014
afmer_2014_final_report_with_cover_-revised_format_2-17-16.pdf, published February 3, 2016, websource:	
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2015
afmer_report_2015_final.pdf, published January 27, 2017, websource:
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2016
afmer_2016_web_report_508.pdf, published January 4, 2018, websource:
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2017
afmer_2017_final.pdf, published January 30, 2019, websource:
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2018
afmer_2018_web_report_final_508.pdf, published January 28, 2020, websource:
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07

Annual Firearms Manufacturing and Export Report, Year 2019
afmer_2019_web_report_final_0.pdf, published January 20, 2021, websource: 	
https://www.atf.gov/resource-center/data-statistics
downloaded 2021-06-07




Data Conversion Information:




        Completed by: Lisa Jordan, Drew University, 36 Madison Ave., Madison, NJ,                                           
                        ljordan@drew.edu
                      Marwa Elessawy, Drew University, 36 Madison Ave., Madison, NJ
                      Graham Munro-Ludders, Drew University, 36 Madison Ave., Madison, NJ
                      Jason Jordan, Drew University, 36 Madison Ave., Madison, NJ




Date of data conversion: 20210607

Geographic location of data conversion: Drew University, Madison, New Jersey 07940, USA

Funding for this project came from the Drew University Digital Humanities Summer Institute (DHSI), funded by a grant from the Andrew W. Mellon Foundation.

--------------------------
SHARING/ACCESS INFORMATION
-------------------------- 


Licenses/restrictions placed on the data, or limitations of reuse: as is


Recommended citation for the data: 


ATF. 2021. "Annual Firearms Manufacturing and Export Report." Originally published by the Bureau of Alcohol, Firearms and Tobacco (ATF), 2000-2021, Washington, DC. Downloaded 7 June 2021 from https://www.atf.gov/resource-center/data-statistics (2007-2019), Homeland Security Digital Library (2000,2002-2004), and GitHub (Ry Jones, 2001, 2005-2006).  Data compiled, merged, aggregated, appended, and stored to .csv format by L. Jordan, M. Elessawy, G. Munro-Ludders, J. Jordan. 7 June. Available online from Harvard Dataverse.




--------------------
DATA & FILE OVERVIEW
--------------------


AFMER Time Series 2000-2019.csv: included all data from ATF, 2000-2019, and two new variables (fields) for each year: mfgtotal, and exptotal.  Please note: data are listed by RDS KEY, a unique identifier by manufacturer location.  There are multiple instances for some companies (e.g. Sturm, Ruger & Company, Inc. is listed as producing in multiple locations, and contains different records or rows for each location).  


Data derived from: 
Department of Justice, Bureau of Alcohol, Tobacco, Firearms and Explosives, 2000-2019. ANNUAL FIREARMS MANUFACTURING AND EXPORT REPORT 2000-2019. Washington, DC.




--------------------------
METHODOLOGICAL INFORMATION
--------------------------




Description of methods used for collection/generation of data: 




AFMER Time Series 2000-2019.csv was created by 1) exported each ATF .PDF report to an .xls file using Adobe software, 2) the aggregate spreadsheet was separated into several different worksheets based on gun type, 3) the data were cleaned and verified by data compilers and saved as separate .csv files (totals for each of the gun types match summary measures also reported by the Annual Firearms Manufacturing and Export Report), 4) separate .csv files were merged using stata based on the RDS KEY: a unique identifier used by the ATF in processing Federally Licensed Firearms Manufacturers, and 5) new columns called mfgtotal and exptotal were created.  exptotal sums all export firearms listed by ATF.  mfgtotal sums all manufacturing totals listed by ATF.  The data are stored in panel data format.


A detailed summary of AFMER data characteristics can be found here: 
Brauer, Jurgen. “Data Sources and Issues.” The US Firearms Industry. Small Arms Survey, 2013. https://www.jstor.org/stable/resrep10770.8.


Software: .csv files may be viewed in Microsoft Excel, Google Sheets, or in a text reader, such as notepad, or through a web browser. 




--------------------------
DATA-SPECIFIC INFORMATION
--------------------------




AFMER Time Series 2000-2019.csv




Number of variables: 30
Number of cases/rows: 22849 rows, including 1 header row


Variable list: most variable names were adopted from the original ATF document, spaces and capitalizations were removed




rdskey: ID number, unique to each license by location, not by company (company names may duplicate), RDS stands for Region, District, Sequence
year: year record appears in AFMER report

license: name of federal firearms manufacturer licensee
street: location of manufacturer
city: city name
state: state US postal code


miscfaexp: number of miscellaneous firearms exported
miscfamfg: number of miscellaneous firearms sold into commerce by manufacturer

pistolexp: number of pistols exported
pistol22: number of 22 caliber pistols sold into commerce by manufacturer
pistol25: number of 25 caliber pistols sold into commerce by manufacturer
pistol32: number of 32 caliber pistols sold into commerce by manufacturer
pistol380: number of pistol 380s sold into commerce by manufacturer
pistol9mm: number of 9mm pistols sold into commerce by manufacturer
pistol50: number of 50 caliber pistols sold into commerce by manufacturer
pistoltotal: total number of pistols, all types, sold into commerce by manufacturer

rifleexp: number of rifles exported
riflemfg: number of rifles sold into commerce by manufacturer

rvlrexp: number of revolvers exported
rvlr22: number of 22 caliber revolvers sold into commerce by manufacturer
rvlr32: number of 32 caliber revolvers sold into commerce by manufacturer
rvlr357: number of 357 revolvers sold into commerce by manufacturer
rvlr38: number of 38 caliber revolvers sold into commerce by manufacturer
rvlr44: number of 44 caliber revolvers sold into commerce by manufacturer
rvlr50: number of 50 caliber revolvers sold into commerce by manufacturer
rvlrtotl: total number of revolvers sold into commerce by manufacturer

shotgunexp: number of shotguns exported
shotgunmfg: number of shotguns sold into commerce by manufacturer

mfgtotal: the rowsum of miscfamfg, pistoltotal, riflemfg, rvlrtotl, shotgunmfg
exptotal: the rowsum of miscfaexp, pistolexp, rifleexp, rvlrexp, and shotgunexp

For the following attribute definitions, this metadata adopts Brauer’s definition of AFMER numbers as “sales into commerce, i.e.g to wholesalers, retailers, or directly to end users, whether from current-year production or from prior-year inventories” (p. 17, The US Firearms Industry: Production and Supply)

Missing data codes: left blank, <NULL>

This metadata is based on the Cornell University readme template, available online: https://cornell.box.com/v/ReadmeTemplate [last downloaded 14 May 2019]